2015-09-08 - 21623 - Spec - Regional bex query creation for EPM260 #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
21623 - Regional bex query creation for EPM260
Purpose
Need to add Material Category ZBPCMG5 & Season Collection Consolidation ZSEACOLCN characteristics in regional BPC sources & to create Regional BEx Queries on corresponding sources for EPM260 - Category Scorecard regional reports.
Admin Info
Purpose
|
Need to create Regional BEx Queries for regional reports.
|
Requested By
|
Danny Moult
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
09/09/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZNA_BPC, ZEA_BPC, ZEM_BPC, ZJA_BPC & ZEJ_BPC.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
02
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
04
|
5
|
Testing in QUA
|
02
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create regional BEx Queries for EPM260 - Category Scorecard.
In Scope:
All the Regional BPC sources needs to be changed.
Out of Scope:
Other BEx queries.
Solution Summary
1. Need to add Category & Season Collection Consolidation object in the regional BPC sources.
2. Need to create BEx Queries on Regional BPC sources.
3. Need to validate the BEx queries against the NEC Standard checklist.
4. Need to collect the BEx Queries into the transport request.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Check if the data is populated successfully for ZBPCMG5 & ZSEACOLCN characteristics.
|
Data should be populated successfully for ZBPCMG5 & ZSEACOLCN characteristics.
|
2
|
Check if all the objects are collected into the transport request.
|
All the objects should be collected into the transport request.
|
Solution Details
1. Need to add ZSEACOLCN(Season Consolidation) in Z_OPN, Z_CNTR, Z_COPA & Z_COND SPO's.
2. Need to add ZBPCMG5(Category) & ZSEACOLCN(Season Consolidation) in the regional BPC sources.
3. Need to create BEx Queries on Regional BPC sources.
4. Need to validate the BEx queries against the NEC Standard checklist.
5. Need to collect the BEx Queries into the transport request.
6. Need to map the BEx Queries with the regional reports.
Issues
None